package com.cnsuning.jobtool.jobtools.tablecreate;

import org.apache.commons.io.FileUtils;
import org.junit.Test;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

public class TableCreateTime {
    @Test
    public void test() throws IOException {
        File sqlFile = new File("src\\main\\java\\com\\cnsuning\\jobtool\\jobtools\\tablecreate\\业务库所有表ddl .sql");
        List<String> lineList = FileUtils.readLines(sqlFile);
        List<String> tableSqlList = new ArrayList<>();
        String tableStr = null;
        for (String line : lineList)
        {
            if (line.startsWith("DROP TABLE ")){
                tableStr+=line;
            }
        }
    }
}
